M/508/0495 - Technology In Communicating And Retrieving Data In Tesco

TASK 1

a) Description

This task is about a retail organization "TESCO" which is working in UK. It is related with regular brand of two reduced grocery store chains having in general of 10000 stores in just about 20 countries with the aggregate turnover of £50 billion. This specific organization bargains in sustenance, refreshments, clean articles and family unit items. The aggregate number of 104400 representatives are working with the organization to conveyance more suitable development risks in coming time. It has encounters extensive variety of development in UK by overwhelming the past outcomes keeping in mind the end goal to wind up most productive organization in coming time. Organisation is running successfully in West London and it is analyse that the organisation is seeking for expanding the scale of business at next level. There are type of strategies and plans are considered in this context related to define the organisational structure and boosting the structure of organisation (Lark, Craven and Bosworth, 2013).

As per analysis of case scenario it is seen that the organisation is required to Expand the business at next level. It is analysed that for further expansion and increasing the amount of business it is required to collect the amount of £10000 form Family and friends, 2500 in the form of capital and 50000 for the goods. Financial requirement is fulfilled with the help of goodwill and repayment capacity. There are some methods are analysed in terms of auto sum, Auto format, average formula, percentage, and in the form of spread sheet.

b) Graph of spreadsheet which contains of total sales and expenses

Sales figures

The profitability graph of organisation shows the positive reflection and helps to analyse the data in various form (Ratrout, 2014). Cost of goods sold is recorded as for the month of April 325000, £295000 for may, £385000 for the month of June, £398500 for the month of July, £350750 for the month of August, £352000 for the month of September, £450000 for the month of October, £395750 for the month of November, £425000 for the month of December and £450500 for the month of January.

As per analysis of sales and profitability graph it is concluded that the turnover for the month of April was £575000, £500000 for may, £595000 for the month of June, £600000 for the month of July, £675000 for the month of August, £50000 for the month of September, £625000 for the month of £700000, £575000 for the month of December, £675000 for the month of January.

Expenses

From the above segment visit, it has been discover that all the those costs TESCO organization will contribute over the creation of items and administrations amid the time frame. Based on above examination, it has been break down that most extreme capital is contributed over organization costs and office costs (Parent, 2013). This will expand additional weight over the creation and aggregate deal amid the time. There are major three type of organisations are defined in this context in terms of expenses which are depreciation, administration expense, office expenses and depreciation.

As per expenditure graph the administration expenses for the 10 months are as follows 7500 for the month of April, 6500 for the month of may, 8500 for the month of June, 9850 for the month of July, 9350 for August month, 10750 for the month of September, 7500 for the month of October, 7650 for the month of November, 3650 the December, 5500 for the month of January.

Office expensed for the ten months are as follows; 10800 for the month of April, 14600 for the month of May, £13600 for the month of June, £11000 for the month of July, £12750 for the month of August, £13870 for the month of September, £14890 for the month of October, £22500 for the month of November, £13500 for the month of December and 23660 for the month of January.

Depreciation for the subsiding ten months which is as follows; 17500 for the month of April, 15700 for the month of May, 16700 for the month of June, 12500 for the month of July, 17900 for the month of August, 19000 for the month of September, 18500 for the month of October, 23500 for the month November, 21470 for the month of December and 25400 for the month of January.

Profitability in last three months

As indicated by the above graph, it has been discover that aggregate deals caused amid the time is fluctuating in following months. The most extreme deals is acquire in the long stretch of January with aggregate of £625000 and also in October. This will be fundamental to gathered important wellsprings of assets for the organization. Keeping in mind the end goal to get more supports, they have to make utilization of held gaining and proprietors value which is more secure and safe to raise capital for the organization (Richards, 2014).

Bifurcation of revenue through charts